Model Table SALES QUOTATION LINE

This model fact represents information about sales quotations which is a pre-step of customer orders and is based on the IFS Cloud dimension FACT_SALES_QUOTATION_LINE. All models that refers to this fact will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Additional Discount	An additional discount (%) which is added to the sales quotation and lines.
Charged Item	A sales quotation line which should be invoiced.
Charged Item Description	A sales quotation line which should be invoiced.
Conversion Factor	The conversion factor between the sales unit of measure (UoM) and inventory UoM.
Currency Rate	The currency rate used conversion between curr amount and amount.
Demance Code
Demance Code Description
Discount	The line discount percentage.
Group Discount	The discount percentage applicable to the sales part's discount group.
Line Item Number	Line item number connected to sales quotation
Line Number	The identity number of the sales quotation line.
Lost To	If the quotation line was lost, this is the competitor who won the deal.
Price Conversion Factor	The conversion factor used to convert the sales quantity expressed in sales unit of measure (UoM) to the quantity expressed in price UoM.
Price List Number	The price list from which the prices are fetched for the quotation line.
Probability To Win	The estimated probability to win the deal.
Quotation Number	The identity number of the sales quotation.
Rental	Indicates whether the order line is a rental line.
Rental Description	Description of the rental line
Sale Unit Price	The unit price.
Sales Part Type	Indicates if the quotation line part is an inventory part or a non-inventory part.
Sales Part Type Description	Indicates if the quotation line part is an inventory part or a non-inventory part.
Sales Unite Measure	The sales unit of measure in which the part is sold, e.g., piece, meter, or kilo.
State	The status of the quotation line.
State Description	The status of the quotation line.
Supply Code	The supply code specifies how a part should be supplied.
Supply Code Description	The supply code specifies how a part should be supplied.
Tax Code	Tax code
Tax Code Description	Tax code

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
SALES QUOTATION LINE	FACT_SALES_QUOTATION_LINE_TM	FACT_SALES_QUOTATION_LINE_BI	FACT_SALES_QUOTATION_LINE	Data Mart